<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateYbzDeleteTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('nw_ybz_delete', function (Blueprint $table) {
          $table->id();

          $table->string('date')->comment('日期');
            
          // 涉及资源集
          $table->string('system_name')->comment('涉及资源集');
          
          // 组件
          $table->string('component')->comment('组件');
          
          // 资源名称
          $table->string('resource_name')->comment('资源名称');
          
          // IP地址
          $table->string('ip')->comment('IP地址');
          
          // 原vcpu
          $table->integer('original_vcpu')->comment('原vcpu');
          
          // 原内存
          $table->integer('original_memory')->comment('原内存');
          
          // 原存储
          $table->integer('original_storage')->comment('原存储');
          
          // 改后cpu
          $table->integer('modified_cpu')->comment('改后cpu');
          
          // 改后内存
          $table->integer('modified_memory')->comment('改后内存');
          
          // 改后存储
          $table->integer('modified_storage')->comment('改后存储');
          
          // 变化值cpu
          $table->integer('change_value_cpu')->comment('变化值cpu');
          
          // 变化值内存
          $table->integer('change_value_memory')->comment('变化值内存');
          
          // 变化值存储
          $table->integer('change_value_storage')->comment('变化值存储');
          
          // 类型
          $table->string('type')->comment('类型');
          
          // 备注
          $table->text('remark')->comment('备注');
          $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('nw_ybz_delete');
    }
}
